Dear all!
I have some monthly inflation CPI data and wanted to create two new time series. First, to annualize them and then to generate a new series of a two percent (2%) average annual inflation increase rate. My example is provided below. Which, as final goal I have to compare with the quarterly data again below in a graph. The constant annual constant 2% average inflation increase rate should be shown probably with a straight line.
I'd be grateful if you could point me in the right direction.
Thank you so much for your help.
Mario,
Monthly data
Quarterly
I have some monthly inflation CPI data and wanted to create two new time series. First, to annualize them and then to generate a new series of a two percent (2%) average annual inflation increase rate. My example is provided below. Which, as final goal I have to compare with the quarterly data again below in a graph. The constant annual constant 2% average inflation increase rate should be shown probably with a straight line.
I'd be grateful if you could point me in the right direction.
Thank you so much for your help.
Mario,
Monthly data
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(time cpimonthly) 14245 76.54 14276 76.78 14304 76.93 14335 76.97 14365 77.06 14396 77.03 14426 77.04 14457 77.04 14488 77 14518 77.04 14549 77.14 14579 77.27 14610 77.21 14641 77.41 14670 77.49 14701 77.66 14731 77.67 14762 77.79 14792 77.85 14823 77.94 14854 77.95 14884 78.04 14915 78.14 14945 78.46 14976 78.24 15007 78.41 15035 78.86 15066 79.31 15096 79.56 15127 79.7 15157 79.67 15188 79.66 15219 79.83 15249 80.07 15280 80.12 15310 80.6 15341 80.64 15372 80.75 15400 81.16 15431 81.4 15461 81.6 15492 81.63 15522 81.54 15553 81.56 15584 81.73 15614 81.89 15645 81.96 15675 82.35 15706 82.05 15737 82.28 15765 82.71 15796 83.06 15826 83.17 15857 83.28 15887 83.09 15918 83.17 15949 83.49 15979 83.65 16010 83.71 16040 84.01 16071 83.7 16102 83.93 16131 84.41 16162 84.78 16192 84.9 16223 85.02 16253 84.76 16284 84.81 16315 84.95 16345 85.08 16376 85.12 16406 85.61 16437 85 16468 85.22 16496 85.73 16527 85.94 16557 86.18 16588 86.15 16618 85.82 16649 85.91 16680 86.14 16710 86.34 16741 86.41 16771 86.82 16802 86.17 16833 86.39 16861 86.9 16892 87.28 16922 87.45 16953 87.53 16983 87.28 17014 87.36 17045 87.67 17075 87.92 17106 88.01 17136 88.37 end format %td time
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input float(time cpiquarterly ) 156 76.75 157 77.02 158 77.02666 159 77.15 160 77.37 161 77.70667 162 77.91333 163 78.21333 164 78.50333 165 79.52333 166 79.72 167 80.26334 168 80.85 169 81.54333 170 81.61 171 82.06667 172 82.34666 173 83.17 174 83.25 175 83.79 176 84.01334 177 84.9 178 84.84 179 85.27 180 85.31667 181 86.09 182 85.95667 183 86.52333 184 86.48666 185 87.42 186 87.43667 187 88.1 188 88.17667 189 89.2 190 89.19333 191 90.15334 192 90.44 193 91.49333 194 91.55333 195 92.22667 196 92.01667 197 92.81 198 92.45333 199 92.98 200 92.69334 201 93.66333 202 93.50333 203 94.15666 204 93.94666 205 95.31333 206 95.04333 207 96.00667 208 95.74333 209 97.10667 210 96.82 211 97.74667 212 97.37 213 98.60667 214 98.28333 215 98.75667 216 98.31667 217 99.27666 218 98.89 219 99.37 220 98.89333 221 100.39333 222 100.19666 223 100.52333 224 99.80334 225 101.18 226 101.08 227 101.32 228 100.86667 229 102.39333 230 102.36667 231 102.52666 232 102.05333 233 103.74 234 103.76 235 103.77666 236 103.24 237 104.94667 238 104.94 239 105.17333 240 104.62666 241 106.41334 242 105.83334 243 105.75667 244 105.90334 245 107.27 246 107.42 247 108.34 248 109.09333 249 112.17667 250 113.71 251 115.96667 end format %tq time
Comment